package saxon;

import saxon.util.JdbcUtil;

import java.sql.Connection;
import java.sql.Statement;

public class TestUtil {
    public static void main (String[] args)throws Exception {
        String url = "jdbc:mysql://rm-wz917wbvou67a757quo.mysql.rds.aliyuncs.com:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=true";
        String userName = "saxon";
        String password = "19990707";
        Connection connection = JdbcUtil.getConnection (url, userName, password);
        String sql = "INSERT INTO result VALUES(\"1005\",\"3\",\"2020-05-14 16:00:00\",\"100\");";
        String check="SELECT * FROM `result` WHERE `studentno`='1000'";
        Statement statement = connection.createStatement ();
        System.out.println (statement.executeUpdate (sql));
    }
}
